microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 1

Which of the following formulas is not entered correctly?

a) =10+50

b) =B7*B1

c) =B7+14

d) 10+50

e) None of these

Answer: (d)

Question : 2

Each cell in a Microsoft Office Excel document is referred to by its cell address, which is the

a) cell's column label

b) cell's column label and worksheet tab name

c) cell's row label

d) cell's row and column labels

e) None of these

Answer: (d)

Question : 3

In Excel you can use the formula palette to

a) Format cells containing numbers

b) Create and edit formulas containing functions

c) Entered assumptions data

d) Copy a range of cells

Answer: (b)

Question : 4

Auto Calculate will quickly add selected cells if you.......

a) right click on the status bar and select Sum

b) click the AutoCalculate but-ton on the toolbar

c) use the key combination Ctrl+$

d) Double click the selection

e) None of these

Answer: (b)

Question : 5

The Trace Precedence on Auditing shows

a) Which cells are used in current formula

b) In which formula the current cell is used

c) Which cells are used in this formula and in which formula this cell is used

d) All of above

e) None of these

Answer: (a)

IMPORTANT computer mcq EXERCISES

microsoft excel q/a Shortcuts »

Click to Read...

MS excel set 4 Online Quiz

Click to Start..
368 microsoft excel qa based computer MCQ MS excel set 4 question answer with explanation pdf

Recently Added Subject & Categories For All Competitive Exams

SSC STENO: Time & Work Questions Solved Problems with PDF

Free Time and work Aptitude-based Practice multiple questions with solutions, Quiz series, Mock Test & Downloadable PDF for SSC Steno (Grade C & D) 2024 Exam

27-Apr-2024 by Careericons

Continue Reading »

SSC STENO 2024: Free Reading Comprehension MCQ Test PDF

Top Reading Comprehension English Section-wise multiple choice questions and answers, Full Mock Test Series & Online Quiz for SSC Steno Grade C & D 2024 Exam

26-Apr-2024 by Careericons

Continue Reading »

Free Percentage Questions Answers for SSC STENO 2024 Exam

Important Top Percentage Aptitude-based multiple choice questions and answers practice quiz series, Online Mock Test PDF for SSC Steno Grade C & D 2024 Exam

25-Apr-2024 by Careericons

Continue Reading »

Free Antonyms (English) MCQ Test for SSC STENO 2024 Exam

Top Antonyms General English Section-based multiple choice questions and answers, Free Full Test Series & Online Quiz PDF for SSC Steno Grade C & D 2024 Exam

24-Apr-2024 by Careericons

Continue Reading »